/**
 * Copyright (C) 2018-2021
 * All rights reserved, Designed By www.yixiang.co
 * 注意：
 * 本软件为www.yixiang.co开发研制，未经购买不得使用
 * 购买后可获得全部源代码（禁止转卖、分享、上传到码云、github等开源平台）
 * 一经发现盗用、分享等行为，将追究法律责任，后果自负
 */
package co.yixiang.modules.distributor.service.mapper;

import co.yixiang.common.mapper.CoreMapper;
import co.yixiang.modules.distributor.domain.DistributorPrice;
import co.yixiang.modules.distributor.vo.DistributorPriceDto;
import co.yixiang.modules.distributor.vo.DistributorPriceVo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
* @author ysl
* @date 2021-11-21
*/
@Repository
public interface DistributorPriceMapper extends CoreMapper<DistributorPrice> {

    @Select("select price.*,dis.distributor_name from distributor_price price, yx_distributor dis where \n" +
            "price.distributor_id = ${id} and dis.distributor_id = price.distributor_id")
    List<DistributorPriceDto> queryDistributorPricesByDisId(@Param("id")String id);
}
